WithCar

Tables (9)

COMMENTS (Untitled3)

  • COMMENTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • CUSTNO (FORIGN KEY) — NUMBER — Foreign key → MAP.CUSTNO — NOT NULL
  • CONTENT (Field) — VARCHAR2
  • NAME (Field2) — VARCHAR2

FNQ (CopyOfUntitled52)

  • CUSTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR2
  • CONTENT (Field2) — VARCHAR2
  • VIEWCOUNT (Field3) — NUMBER
  • REGDATE (Field4) — DATE

LIKES (Untitled4)

  • LIKESNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • CUSTNO (FOREIGN KEY) — NUMBER — Foreign key → MAP.CUSTNO — NOT NULL
  • ID (Field) — VARCHAR2

MAP (Untitled2)

  • CUSTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • ID (Field13) — VARCHAR2 — Foreign key → MEMBER.ID
  • ID (Field11) — VARCHAR2
  • NAME (Field) — VARCHAR2
  • LOCATION (Field2) — VARCHAR2
  • ADDRESS (Field3) — VARCHAR2
  • LAT (Field4) — NUMBER
  • LNG (Field5) — NUMBER
  • TITLE (Field6) — VARCHAR2
  • CONTENT (Field7) — VARCHAR2
  • IMGURL (Field8) — VARCHAR2
  • REGDATE (Field9) — DATE
  • VIEWCOUNT (Field10) — NUMBER
  • LIKES (Field12) — NUMBER

MEMBER (Untitled)

  • BNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • ID (Field) — VARCHAR2 — Primary key
  • PW (Field2) — VARCHAR2
  • NAME (Field3) — VARCHAR2
  • EMAIL (Field4) — VARCHAR2
  • TEL (Field5) — VARCHAR2
  • GU (Field6) — NUMBER

NOTICE (Untitled5)

  • CUSTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR2
  • CONTENT (Field2) — VARCHAR2
  • VIEWCOUNT (Field3) — NUMBER
  • REGDATE (Field4) — DATE

QCOMMENTS (CopyOfUntitled3)

  • COMMENTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • CUSTNO (PRIMARY KEY2) — NUMBER — Foreign key → QNA.CUSTNO — NOT NULL
  • CONTENT (Field) — VARCHAR2
  • NAME (Field2) — VARCHAR2
  • ID (Field3) — VARCHAR2

QNA (CopyOfUntitled5)

  • CUSTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • ID (Field7) — VARCHAR2 — Foreign key → MEMBER.ID
  • TITLE (Field) — VARCHAR2
  • CONTENT (Field2) — VARCHAR2
  • VIEWCOUNT (Field3) — NUMBER
  • REGDATE (Field4) — DATE
  • NAME (Field6) — VARCHAR2

REVIEW (CopyOfCopyOfUntitled522)

  • CUSTNO (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
  • ID (Field8) — VARCHAR2 — Foreign key → MEMBER.ID
  • TITLE (Field) — VARCHAR2
  • CONTENT (Field2) — VARCHAR2
  • VIEWCOUNT (Field3) — NUMBER
  • REGDATE (Field4) — DATE
  • NAME (Field6) — VARCHAR2
  • IMGURL (Field7)