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