test

Tables (10)

CODE_SUB

  • CODE_SUB_ID — varchar(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • CODE_SUB_EXPLAIN — varchar(100)
  • CODE_SUB_NAME — varchar(20)

CODE_SUPER

  • CODE_SUPER_ID — varchar(255) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • CODE_SUPER_EXPLAIN — varchar(100)
  • CODE_SUPER_NAME — varchar(20) — NOT NULL

FAQ

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • FAQ_CONTENT — text — NOT NULL
  • FAQ_TITLE — varchar(200) — NOT NULL

FILE

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • FILE_EXTENSION — varchar(10) — NOT NULL
  • FILE_NAME — varchar(200) — NOT NULL
  • FILE_ORIGINAL_NAME — varchar(200) — NOT NULL
  • FILE_PATH — varchar(200) — NOT NULL
  • FILE_SAVE_PATH — varchar(200) — NOT NULL
  • FILE_TYPE — varchar(10) — NOT NULL
  • FILE_FAQ — bigint(20) — Foreign key → FAQ.ID
  • FILE_NOTICE — bigint(20) — Foreign key → NOTICE.ID
  • FILE_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID
  • FILE_MEMBER — varchar(100) — Foreign key

NOTICE

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • NOTICE_CONTENT — text — NOT NULL
  • NOTICE_TITLE — varchar(200) — NOT NULL

SCHEDULE

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • SCHEDULE_ALL_TIME_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_YN — bit(1) — NOT NULL
  • SCHEDULE_LUNAR_YN — bit(1) — NOT NULL
  • SCHEDULE_REPEAT_YN — bit(1) — NOT NULL
  • SCHEDULE_REPEAT_MONTH — bigint(20)
  • SCHEDULE_REPEAT_WEEK — varchar(255)
  • SCHEDULE_REPEAT_YEAR — varchar(5)
  • SCHEDULE_SCHEDULE_START_DATE — datetime — NOT NULL
  • SCHEDULE_REPEAT_END_DATE — datetime
  • SCHEDULE_TITLE — varchar(100) — NOT NULL
  • SCHEDULE_USER_INFO — text — NOT NULL
  • SCHEDULE_MEMBER — varchar(100) — Foreign key — NOT NULL
  • SCHEDULE_CONTENT — text
  • SCHEDULE_COLOR — varchar(50) — NOT NULL
  • SCHEDULE_ALARM_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_DDAY1_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_DDAY2_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_DDAY3_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_DDAY_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_MDAY1_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_TIME — varchar(255)
  • SCHEDULE_DDAY_YDAY1_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_YDAY2_YN — bit(1) — NOT NULL
  • SCHEDULE_DDAY_YDAY3_YN — bit(1) — NOT NULL
  • SCHEDULE_SHARE_YN — bit(1) — NOT NULL

SCHEDULE_ALARM_TYPE

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • SCHEDULE_ALARM_TYPE_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL

SCHEDULE_GOOD

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • SCHEDULE_GOOD_MEMBER — varchar(100) — Foreign key — NOT NULL
  • SCHEDULE_GOOD_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL

SCHEDULE_REPLY

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • SCHEDULE_REPLY_CONTENT — text
  • SCHEDULE_REPLY_MEMBER — varchar(100) — Foreign key — NOT NULL
  • SCHEDULE_REPLY_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL

SCHEDULE_TYPE

  • ID — bigint(20) — Primary key — NOT NULL
  • modDate — datetime
  • regDate — datetime
  • SCHEDULE_TYPE_SCHEDULE — bigint(20) — Foreign key → SCHEDULE.ID — NOT NULL