gogildong

Tables (4)

like (Untitled4)

  • PK (PK_like) — number,varchar2(300) — Primary key — NOT NULL
  • FK (FK_like_review) — number — Foreign key → review.PK — NOT NULL
  • PK (PK_member) — varchar2(300) — Foreign key → member.PK — NOT NULL
  • Field — sysdate
  • Field2 — number

member (Untitled3)

  • PK (PK_member) — varchar2(300) — Primary key — NOT NULL
  • Field — varchar2(100)
  • Field2 — varchar2(100)
  • Field3 — varchar2(300)

review (Untitled2)

  • PK (PK_review) — number — Primary key — NOT NULL
  • FK (FK_review_store) — number — Foreign key → store.PK — NOT NULL
  • FK (FK_review_member) — varchar2(100) — Foreign key → member.PK — NOT NULL
  • Field3 — varchar2(500)
  • Field4 — number(10,2)
  • Field5 — varchar2(300)
  • Field6 — sysdate
  • Field7 — sysdate

store (Untitled)

  • PK (PK_store) — number — Primary key — NOT NULL
  • Field — varchar2(300)
  • Field2 — varchar2(300)
  • Field3 — number(10,6)
  • Field4 — number(10,6)
  • Field5 — varchar2(300)
  • Field6 — varchar2(100)
  • Field7 — sysdate
  • Field8 — sysdate
  • Field9 — number