Trello

Tables (9)

Activity (활동)

  • ac_seq (Key) — Primary key — NOT NULL
  • ac_code (Field4)
  • content (Field2)
  • cmnt_Id (Field5)
  • cmnt_att (Field10)
  • like_cnt (Field6)
  • udt_yn (Field7)
  • del_yn (Field8)
  • cre_id (Field)
  • cre_dt (Field3)
  • card_code (Key22) — Foreign key → Card.card_code — NOT NULL

Attachment (첨부파일)

  • attach_seq (Key) — Primary key — NOT NULL
  • img_url (Field)
  • cred_dt (Field3)
  • card_code (Key22) — Foreign key → Card.card_code — NOT NULL

Board (보드)

  • board_seq (Key) — Primary key — NOT NULL
  • board_code (Key2) — Primary key — NOT NULL
  • board_name (Field2)
  • visibility (Field3)
  • bookmark_yn (Field6)
  • del_yn (Field4)

Board_Admin (보드 관리자)

  • admin_seq (Key) — Primary key — NOT NULL
  • board_code (Key2) — Foreign key → Board.board_seq — NOT NULL
  • user_id (Key22) — Foreign key → Member.user_id — NOT NULL

Card (카드)

  • card_seq (Key) — Primary key — NOT NULL
  • card_code (Key2) — Primary key — NOT NULL
  • title (Field2)
  • desc (Field3)
  • cover (Field5)
  • list_code (Key22) — Foreign key → List.list_code — NOT NULL

Group (유저그룹)

  • group_seq (Key) — Primary key — NOT NULL
  • group_code (Field)
  • group_name (Field2)
  • board_code (Key22) — Foreign key → Board.board_code — NOT NULL
  • user_id (Key23) — Foreign key → Member.user_id — NOT NULL

List (리스트(카테고리))

  • list_seq (Key) — Primary key — NOT NULL
  • list_code (Key2) — Primary key — NOT NULL
  • list_name (Field2)
  • board_code (Key22) — Foreign key → Board.board_code — NOT NULL

Member (유저)

  • user_seq (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • user_name (Field2)
  • user_email (Field3)
  • password (Field4)
  • user_status (Field5)
  • del_yn (Field8)
  • login_fail_cnt (Field10)
  • login_dt (Field9)
  • cred_dt (Field6)
  • udt_dt (Field7)

MemberNoti (카드팔로우)

  • noti_seq (Key) — Primary key — NOT NULL
  • user_id (Key22) — Foreign key → Member.user_id — NOT NULL
  • card_code (Key23) — Foreign key → Card.card_code — NOT NULL