EntityPratice
Tables (26)
Address (주소)
- Id (Key) — PK — Primary key — NOT NULL
- name (Field) — varchar
Board2 (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → Member2.id — NOT NULL
- title (Field) — varchar
- contents (Field2) — longtext
- created_at (Field3) — datetime
- update_at (Field4) — datetime
Build (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- name (varchar) — varcahr
Build (Untitled3)
- id (Key) — PK — Primary key — NOT NULL
- person_list (Key22) — Foreign key → Person.build_id — NOT NULL
- Field — varcahr
Build (건물)
- id (Key) — PK — Primary key — NOT NULL
- name (Field) — varchar
Build2 (건물2)
- Id (Key) — PK — Primary key — NOT NULL
- name (Field) — varcahr
Company (회사)
- Key — Primary key — NOT NULL
- name (Field) — varchar
Delivery (배달)
- id (Key) — Long — Primary key — NOT NULL
- address (Field) — varchar
Item (품목)
- id (Key) — Long — Primary key — NOT NULL
- orderItems (Key22) — List(1:N) — Foreign key → Orders.member_id — NOT NULL
- name (Field) — varcahr
Language (언어)
- id (Key) — PK — Primary key — NOT NULL
- name (Field) — varchar
Member (회원)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — varchar
Member2 (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — varcahr
- age (Field2) — Integer
- password (Field3) — varchar
- created_at (Field5) — datetime
- update_at (Field6) — datetime
OrderItem (주문품목)
- id (Key) — Long — Primary key — NOT NULL
- Item_id (Key2) — FK — Foreign key → Item.id — NOT NULL
- Order_id (Key3) — FK — Foreign key → Orders.id — NOT NULL
- orderPrice (Field) — Integer
- count (Field2) — Integer
Orders (주문)
- id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — FK — Foreign key → Member.id — NOT NULL
- delibvery_list (Key3) — Long — Foreign key → Delivery.id — NOT NULL
- orderDate (Field) — Datetime
Person (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- build_id (Key2) — Long — Foreign key → Build.id — NOT NULL
- name (Field2) — varchar
Person (사람4)
- id (Key) — PK — Primary key — NOT NULL
- company_id (Key2) — BigInt — Foreign key → Company.Key — NOT NULL
- name (Field) — varcahr
Person (사람3)
- id (Key) — PK — Primary key — NOT NULL
- name (Field) — varcahr
Person (사람2)
- Id (Key) — PK — Primary key — NOT NULL
- address_Id (Key2) — FK(bigint) — Foreign key → Address.Id — NOT NULL
- build_id (Key3) — FK(bigint) — Foreign key → Build2.Id — NOT NULL
- name (Field) — varcahr
Person (사람)
- Id (Key) — PK — Primary key — NOT NULL
- build_id (Key2) — FK — Foreign key → Build.id — NOT NULL
- name (Field) — varcahr
Person (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- build_id (Key2) — Long — Foreign key → Build.id — NOT NULL
- name (Field) — varcahr
PersonLanguage (중간테이블)
- id (Key3) — PK — Primary key — NOT NULL
- language_id (Key2) — FK — Foreign key → Language.id — NOT NULL
- person_id (Key) — FK — Foreign key → Person.id — NOT NULL
- level (Field) — BIGINT
- licence (Field2) — VARCHAR
ProductImage (제품이미지)
- filename (Field) — varcahr(255)
- ord (Field2) — BigInt
Todo (할일)
- tno (Key) — auto_increment — Primary key — NOT NULL
- title (Field) — varchar(500)
- content (Field2) — varchar(255)
- complete (Field3) — boolean
- dueDate (Field4) — LocalDate
tdl_product (제품)
- tno (Key) — Primary key — NOT NULL
- name (Field) — varchar(255)
- price (Field2) — BigInt
- delFlag (Field3) — boolena
- pdesc (Field4) — varcahr(255)
사람회사 (FetchJoin)
- Key — Primary key — NOT NULL
- company_id (Key2) — BigInt — Foreign key → 사람회사.Key — NOT NULL
- name (Field) — varcahr
- Field3
사람회사 (FetchJoin2)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → 사람회사.Key — NOT NULL
- name (Field) — varcahr
- Field3