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