KOREAIT
Tables (11)
children (Untitled3)
- id — INT — Primary key
- nickname — VARCHAR(50) — NOT NULL — UQ
- age — INT
- height — INT
- weight — INT
- userId — INT — user(FK)
like (Untitled9)
- id (Key) — INT — Primary key
- name (Field) — VARCHAR(50) — NOT NULL
- imgURL (Field2) — VARCHAR(50)
- period (Field3) — VARCHAR(50) — NOT NULL
- userId (Field4) — INT — user(FK)
post (Untitled4)
- id — INT — Primary key
- title — VARCHAR(50) — NOT NULL
- content — LONGTEXT — NOT NULL
- createDate — DATETIME
- recommendCnt — INT
- userId — INT — user(FK)
post_comment (Untitled6)
- id (Key) — INT — Primary key
- content (Field) — TEXT — NOT NULL
- createDate (Field2) — DATETIME
- userId (Field3) — INT — user(FK)
- postId (Field4) — INT — post(FK)
post_img (Untitled5)
- id (Key) — INT — Primary key
- postId (Field) — INT — post(FK)
product (Untitled7)
- id (Key) — INT — Primary key
- name (Field) — VARCHAR(50) — NOT NULL
- region (Field2) — VARCHAR(50) — NOT NULL
- price (Field3) — VARCHAR(50)
- content (Field4) — TEXT — NOT NULL
- userId (Field5) — INT — user(FK)
product_comment (CopyOfUntitled6)
- id (Key) — INT — Primary key
- content (Field) — TEXT — NOT NULL
- createDate (Field2) — DATETIME
- userId (Field3) — INT — user(FK)
- postId (Field4) — INT — post(FK)
product_img (Untitled8)
- id (Key) — INT — Primary key
- productId (Field) — INT — product(FK)
user (Untitled)
- id — INT — Primary key
- nickname — VARCHAR(50) — NOT NULL
- password — INT — NOT NULL
- email — VARCHAR(50) — NOT NULL
- createDate (Field) — DATETIME
user_authorities (Untitled2)
- userId — INT — NOT NULL — USER(FK)
- authorityId — INT — NOT NULL — user_authority(FK)
- id — INT — Foreign key → user.id
- id (id2) — INT — Foreign key → user_authority.id
user_authority (CopyOfUntitled2)
- id — INT — Primary key
- name — VARCHAR(50) — NOT NULL — UQ