SpringProject
Tables (10)
ATTENDEE (Untitled10)
- USER_ID (ID) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- POST_ID — NUMBER(20) — Foreign key → BOARD.POST_ID — NOT NULL
BOARD (Untitled2)
- POST_ID — NUMBER(20) — Primary key — NOT NULL
- USER_ID (ID2) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- TITLE — VARCHAR2(40Byte)
- CONTENT — VARCHAR2(500Byte)
- TIME — VARCHAR2(20Byte)
- COMCOUNT — NUMBER(3)
- STARTTIME — VARCHAR2(12Byte)
- ENDTIME — VARCHAR2(12Byte)
- STARTDAY — VARCHAR2(12Byte)
- ENDDAY — VARCHAR2(12Byte)
- LOCATION — VARCHAR2(10Byte)
- CATEGORY — VARCHAR2(10Byte)
BOARD_COMMENT (Untitled3)
- IDX (Key) — NUMBER(3) — Primary key — NOT NULL
- USER_ID (ID) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- POST_ID — NUMBER(20) — Foreign key → BOARD.POST_ID — NOT NULL
- CONTENT (Field) — VARCHAR2(100Byte)
- TIME (Field2) — VARCHAR2(20Byte)
CATEGORY (Untitled6)
- ID (Key) — VARCHAR2(10Byte) — Primary key — NOT NULL
- NAME (Field) — VARCHAR2(20Byte)
COMMENT_ALARM (Untitled4)
- IDX (Key) — NUMBER(3) — Foreign key → BOARD_COMMENT.IDX — NOT NULL
- POST_ID — NUMBER(20) — Foreign key → BOARD.POST_ID — NOT NULL
- AUTHOR_ID (ID2) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- WRITER_ID (ID3) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- POST-TITLE (Field) — VARCHAR2(40Byte)
- ISCHECKED (Field2) — VARCHAR2(2Byte)
LOCATION (Untitled5)
- ID (Key) — VARCHAR2(10Byte) — Primary key — NOT NULL
- NAME (Field) — VARCHAR2(20Byte)
MEETING (Untitled8)
- POST_ID — NUMBER(20) — Foreign key → BOARD.POST_ID — NOT NULL
- ORGANIZER_ID (ID2) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- CATEGORY_ID (Key2) — VARCHAR2(10Byte) — Foreign key → LOCATION.ID — NOT NULL
- LOCATION_ID (Key) — VARCHAR2(10Byte) — Foreign key → CATEGORY.ID — NOT NULL
- SUMMARY (Field) — VARCHAR2(30Byte)
- MAX_ATTENDEE (Field2) — NUMBER(3)
- CUR_ATTENDEE (Field3) — NUMBER(3)
TOKENREPOSITORY (Untitled7)
- USER_ID (ID) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- ACCESS_TOKEN (Field) — VARCHAR2(150Byte)
- REFRESH_TOKEN (Field2) — VARCHAR2(150Byte)
USERLIST (Untitled)
- USER_ID (ID) — VARCHAR2(20Byte) — Primary key — NOT NULL
- NAME — VARCHAR2(20Byte)
- PASSWORD — VARCHAR2(65Byte)
USER_CALENDAR (Untitled9)
- USER_ID (ID) — VARCHAR2(20Byte) — Foreign key → USERLIST.USER_ID — NOT NULL
- CALENDAR_ID (Field) — VARCHAR2(40Byte)