ERD_final
Tables (5)
board_table (Untitled)
- BOARD_NO (Key) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (Field2) — VARCHAR2(30)
- BOARD_STATUS (Field3) — NUMBER(1,0)
- BOARD_TITLE (Field4) — VARCHAR2(60)
- BOARD_STARTPOINT (Field5) — VARCHAR2(30)
- BOARD_ENDPONT (Field6) — VARCHAR2(30)
- BOARD_STARTTIME (Field7) — TIMESTAMP(6)
- BOARD_CONTENTS (Field8) — VARCHAR2(500)
car_info_table (Untitled2)
- BOARD_NO (Key) — NUMBER — Foreign key → board_table.BOARD_NO — NOT NULL
- CAR_TYPE (Field2) — VARCHAR2(50)
- MAXSEAT (Field3) — NUMBER(10,0)
- CAR_YEAR (Field4) — MEMBER(10,0)
comment_table (Untitled5)
- COMMENT_NO (Key3) — NUMBER — Primary key — NOT NULL
- BOARD_NO (Key) — NUMBER — Foreign key → board_table.BOARD_NO — NOT NULL
- MEMBER_ID (Key2) — NUMBER — Foreign key → member_table.MEMBER_NO — NOT NULL
- PARENT_NO (Field3) — NUMBER
- COMMENT_CONTENT (Field5) — VARCHAR2(255)
- COMMENT_REGDT (Field6) — DATE
- COMMENT_DEPTH (Field7) — NUMBER
member_table (Untitled3)
- MEMBER_NO (Key) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (Field) — VARCHAR2(255)
- MEMBER_BIRTH (Field2) — VARCHAR2(20)
- MEMBER_EMAIL (Field3) — VARCHAR2(50)
- MEMBER_LICENSE (Field4) — VARCHAR2(30)
- MEMBER_LIKE (Field5) — NUMBER(10,0)
- MEMBER_MOBILE (Field6) — VARCHAR2(30)
- MEMBER_NAME (Field7) — VARCHAR2(20)
- MEMBER_PASSWORD (Field8) — VARCHAR2(255)
passenger_table (Untitled4)
- PASSENGER_TABLE_NO (Key3) — NUMBER — Primary key — NOT NULL
- BOARD_NO (Key2) — NUMBER — Foreign key → board_table.BOARD_NO — NOT NULL
- MEMBER_ID (Key) — NUMBER — Foreign key → member_table.MEMBER_NO — NOT NULL
- PASSENGER_CHECK (Field4) — VARCHAR2(10)