Spaces:
Runtime error
Runtime error
File size: 1,616 Bytes
97dab2a |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 |
import {
Entity,
PrimaryGeneratedColumn,
Column,
ManyToOne,
OneToMany,
JoinColumn,
CreateDateColumn,
UpdateDateColumn,
} from 'typeorm';
import { Customer } from './customer.entity';
import { Employee } from './employee.entity';
import { Shipper } from './shipper.entity';
import { OrderDetail } from './orderdetail.entity';
@Entity('Orders')
export class Order {
@PrimaryGeneratedColumn()
OrderID: number;
@ManyToOne(() => Customer)
@JoinColumn({ name: 'CustomerID' })
Customer: Customer;
@ManyToOne(() => Employee)
@JoinColumn({ name: 'EmployeeID' })
Employee: Employee;
@OneToMany(() => OrderDetail, (OrderDetail) => OrderDetail.Order)
OrderDetails: OrderDetail[];
@Column({ type: 'timestamp', nullable: true })
OrderDate: Date;
@Column({ type: 'timestamp', nullable: true })
RequiredDate: Date;
@Column({ type: 'timestamp', nullable: true })
ShippedDate: Date;
@ManyToOne(() => Shipper)
@JoinColumn({ name: 'ShipVia' })
ShipVia: Shipper;
@Column({ type: 'decimal', precision: 18, scale: 2, nullable: true })
Freight: number;
@Column({ length: 60, nullable: true })
ShipName: string;
@Column({ length: 60, nullable: true })
ShipAddress: string;
@Column({ length: 15, nullable: true })
ShipCity: string;
@Column({ length: 15, nullable: true })
ShipRegion: string;
@Column({ length: 10, nullable: true })
ShipPostalCode: string;
@Column({ length: 15, nullable: true })
ShipCountry: string;
@CreateDateColumn({ type: 'timestamp' })
createdAt: Date;
@UpdateDateColumn({ type: 'timestamp' })
updatedAt: Date;
}
|