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)