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)